package com.his.dao.jpa;

import java.math.BigDecimal;
import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.his.pojo.HisHospitalization;
import com.his.pojo.HisRegistrationForm;

import net.sf.jsqlparser.statement.select.Select;

/*
 *住院通知单dao 
 */
public interface HospitalizationDao extends  CrudRepository<HisHospitalization, Long> {
	@Query("select h from HisHospitalization h order by h.zyNo desc")
	public List<HisHospitalization> findHisHospitalizationByPage(Pageable pageable);
	
	public List<HisHospitalization> findByYlkNo(BigDecimal ylkno);
	
	public HisHospitalization  findByYlkNoAndTzState(BigDecimal ylkno,BigDecimal tzstate);
}
